package DataLayer.DB;

import java.util.ArrayList;

import DataLayer.Model.Kunde;

public interface IFDBKunde
{
	// get all Kunder
	public ArrayList<Kunde> getAllKunde(boolean klubMedlem);

	// get one Kunde having the name
	public ArrayList<Kunde> getAllKundeViaName(String navn);

	// get one Kunde having the tlf.
	public ArrayList<Kunde> getAllKundeViaTlf(String tlf);

	// get one Kunde having the email
	public ArrayList<Kunde> getAllKundeViaEmail(String email);

	// get one Kunde having the address
	public ArrayList<Kunde> getAllKundeViaAdresse(String adresse);

	// get one Kunde having the country
	public ArrayList<Kunde> getAllKundeViaLand(String land);

	// get one Kunde having the zip code
	public ArrayList<Kunde> getAllKundeViaPost(String postnr);

	// get one Kunde having the city
	public ArrayList<Kunde> getAllKundeViaBy(String by);

	// get one Kunde having the id
	public Kunde getKunde(int kundeId);

	// get one Kunde having the name
	public Kunde getKundeViaName(String navn);

	// get one Kunde having the email
	public Kunde getKundeViaEmail(String email);

	// insert a new Kunde
	public int insertKunde(Kunde kunde) throws Exception;

	// update information about an Kunde
	public int updateKunde(Kunde k);

	// delete a Kunde
	public int deleteKunde(Kunde k) throws Exception;
}
